Mysql number of tables in DB

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'databasename';

Leave a Reply